Re: Brain cramp or unsupported SQL?

2001-01-18 Thread Bob Hall
>From what I've read in the docs, this should work, yes? > >select mcorder.ord_id, project.address, mcuser.last_name >from > project inner join > (mcuser inner join >mcorder > on mcuser.usr_id = mcorder.usr_id) > on project.prj_id = mcorder.prj_id; No sir. You've separated th

Re: Brain cramp or unsupported SQL?

2001-01-18 Thread Carsten Gehling
From: "Marcos Minshew" <[EMAIL PROTECTED]> Sent: Wednesday, January 17, 2001 10:05 PM > >From what I've read in the docs, this should work, yes? > > select mcorder.ord_id, project.address, mcuser.last_name > from > project inner join > (mcuser inner join >mcorder > on mcus

Brain cramp or unsupported SQL?

2001-01-17 Thread Marcos Minshew
>From what I've read in the docs, this should work, yes? select mcorder.ord_id, project.address, mcuser.last_name from project inner join (mcuser inner join mcorder on mcuser.usr_id = mcorder.usr_id) on project.prj_id = mcorder.prj_id; Or am I just stoopid today? ---