multitable SQL query 1

[skotman]

This isn't urgent, just me being curious and for future reference.

Is there a way to grab records from multiple tables?

example:

Table1
ID
ParentName
Address
Phone number

Table2
ID
ParentID (from table 1)
KidName

I want to display the ParentName and KidName with out having to query the database twice.

I would have thought that Select Table1.ParentName, Table2.KidName from Table1, Table2 where ParentName = "Joe" would work but it doesnt. I can't find anything on this on the web.

Thanks in advance. I'm just trying to further my SQL knowledge.

 

[onpnt]

peforming JOIN's on the tables is your usual method.

http://www.w3schools.com/sql/sql_join.asp

the SQL forums may be better to ask SQL question for future reference forum183 in particular

_____________________________________________________________________

_{Hakuna matata!!}

 

[skotman]

Thank you!

 

[onpnt]

_____________________________________________________________________

_{Hakuna matata!!}

 

[skotman]

a star for you!