| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | jeff(at)emojo(dot)com (Jeff Rhys-Jones) |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Inner Join? |
| Date: | 2001-07-10 23:32:08 |
| Message-ID: | 16372.994807928@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
jeff(at)emojo(dot)com (Jeff Rhys-Jones) writes:
> Hi there - we've hit a bit of a brick wall with this and I was
> wondering if someone could help us out. Our MS-SQL code is this :
> SELECT ...
> FROM "Site","AppUser"
> WHERE "Site"."SiteCode"=1
> AND "Site"."SecurityContactCode" *= "AppUser"."UserCode"
> And it's the "* =" at the very end of the table which is causing the
> problem.
> Our dev. guy has told me that "*=" in MS speak is INNER JOIN.
I believe it's actually an outer join; inner join is the standard and
wouldn't need any special syntax. You probably want
SELECT ...
FROM "Site" LEFT OUTER JOIN "AppUser" ON
("Site"."SecurityContactCode" = "AppUser"."UserCode")
WHERE "Site"."SiteCode"=1
assuming that I've guessed right...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Rhys-Jones | 2001-07-10 23:35:25 | RE: Inner Join? |
| Previous Message | Tom Lane | 2001-07-10 23:28:19 | Re: Bad news for Open Source databases, acording to survey |