From: | jeff(at)emojo(dot)com (Jeff Rhys-Jones) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Inner Join? |
Date: | 2001-07-04 17:27:07 |
Message-ID: | 7a92561a.0107040927.546871c8@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 "Site"."Name" as "SiteName", "Site"."Description" as
"SiteDescription",
"Site"."DefaultStyle", "Site"."PageWidth",
"Site"."Tel", "Site"."Fax", "Site"."Email", "Site"."Web",
"Site"."UserRegistration", "Site"."UserApprovalRequired",
"Site"."DefaultSecurity", "Site"."GrantedSecurity",
"Site"."KeyWordMeta",
"Site"."DescriptionMeta", "Site"."WhatsNewTF", "Site"."RegIntro",
"Site"."RegConfirm", "AppUser"."Email" as "SecurityContactEmail",
"Site"."TimeZone", "Site"."Logo", "Site"."LogoWidth",
"Site"."LogoHeight",
"Site"."LogoBGColor", "Site"."Favicon", "Site"."PublishingTF",
"Site"."LastPublished", "Site"."MyMessageCodeField",
"Site"."ContactDisplay",
"Site"."SiteUIDCode"
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.
Can anyone out there help us. I have Momjians book here but I'm stuck.
Many thanks,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-07-04 17:52:02 | Re: Re: lo wrappers - still working on it |
Previous Message | Randal L. Schwartz | 2001-07-04 17:09:21 | Re: bit operations |