OpenEuphoria

EuSQL SQL Question

• Posted by cklester <cklester at yahoo.com> Aug 13, 2005
• 445 views

Matt (or any SQL expert),

If I have two tables, one is "members" and the other is "telephone numbers,"
how do I get the telephone numbers of a particular member when all I have is
his/her name? For example, I want all of Joe's telephone numbers... what SQL
query would I use if I wanted it in one query? Thanks!!

table members:
(ID,name)
1, Joe
2, Sally
3, Mark

table telephone numbers:
(recordid,member id, number, type)
1,1,1234567890,home
2,1,2468101214,work
3,1,3691215182,cell
4,2,1234567891,home
5,3,1234567892,home



-=ck
"Programming in a state of EUPHORIA."
http://www.cklester.com/euphoria/