How do i display data from multiple sql tables

[PRAISE PHS]

I am a new vb.net programmer. I am designing a point of sales and inventory windows app. My problem is this:
I want to create a crystal report for my invoice from four tables in my sql database but I dont know how to go about it. Please I need someone to put me through. Thanks and God bless you.

 

[jmcilhinney]

You use a query that includes a join, e.g.

SELECT Parent.ParentName, Child.ChildName
FROM Parent INNER JOIN Child
ON Parent.ParentID = Child.ParentID

You can join as many related tables as you like simply by adding more joins to your SQL statement.

 

[PRAISE PHS]

Thanks a lot moderator for the prompt reply. I will get back to you if it works. Bye.