joins

Last Post 12 Apr 2002 07:30 AM by js_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
js_SQL
New Member
New Member

--
12 Apr 2002 07:30 AM
say i have 2 tables

tablea
apid
aname

tableb
bpid
apid
bdate

and i have info like this
tablea
-------
1
helo

tableb
--------
1
1
2/2/2002 10:00:05

how do i write a query which would give me this
i need to know apid and bpid for bdate = 2/2/2002 10:00:10 if this date exists but it should give me apid where aname = 'helo'


Acceptable Use Policy
---