Home
> Uncategorized > Double joins in access
Double joins in access
With SQL server, there is no problem with joining multiple tables in the same query like so:
select * from a
join b on a.bid = b.id
join c on b.cid = c.id
But this doesn’t work in MS Acess, but this format does
select * from a,b,c
where a.bid= b.id and c.id = b.cid
Advertisements
Categories: Uncategorized
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
