Thanks for all your help on that one guys :) All working now.
On 2 Nov 2005, at 19:36, Hassan Arteaga wrote:
> Hi Stuart
>
> Try "Inner Join" with the key in each table
>
> IE:
>
> Imagine u have two tables Basket and basketDetails in an ecommerce
> application
>
> SELECT*
> FROM
The original OP did have an inner join using the older style of putting the
join in the WHERE clause. If he is on a system like me, using an older Oracle
8i or previous version, he can't use the new fangled (13 year old) syntax of
INNER JOIN, OUTER JOIN, FULL JOIN, CROSS JOIN. Oh how I wish I
Hi Stuart
Try "Inner Join" with the key in each table
IE:
Imagine u have two tables Basket and basketDetails in an ecommerce
application
SELECT*
FROM_C_Basket INNER JOIN
_R_BasketDetails ON _C_Basket.idBasket =
_R_BasketDetails.idBasket
In this ca
SELECT u.userID, u.firstName, u.lastName, e.eventID, e.userID FROM
tbl_020publicUsers u, tbl_020eventDetails e WHERE u.userID = e.userID
By selecting e.eventID from the tbl_020eventDetails e table, every row selected
is going to be distinct. A couple of thing you can do, is not select the dat
that is because you are getting the event details as well e.eventID and
e.userID
if you remove these from the select list and put the DISTINCT back that
should do the trick.
Mike T
On 11/2/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote:
>
> Hi guys,
>
> I'm trying to do something simple b
Stuart:
You need to use an INNER JOIN in your query. The query should be:
SELECT
u.userID,
u.firstName,
u.lastName,
e.eventID,
e.userID
FROM
tbl_020publicUsers u INNER JOIN tbl_020eventDetails e
ON u.userID = e.userID
HTH
--
Mosh Teitelba
creative :)
-- Sam
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 4:55 PM
To: CF-Talk
Subject: RE: SQL DISTINCT Question
Thanks Sam, got the following to work but I like yours better ;)
SELECT Email, FirstName, LastName
FROM Users
WHERE
: RE: SQL DISTINCT Question
try:
SELECT email, first(firstname), first(lastname)
FROM people
GROUP BY email;
-- Sam
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 4:15 PM
To: CF-Talk
Subject: SQL DISTINCT Question
SELECT DISTINCT Email
try:
SELECT email, first(firstname), first(lastname)
FROM people
GROUP BY email;
-- Sam
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 4:15 PM
To: CF-Talk
Subject: SQL DISTINCT Question
SELECT DISTINCT Email
FROM LinkedEmails
returns a
.
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]]
Sent: 02 November 2001 10:28
To: CF-Talk
Subject: RE: sql distinct
Doesn't the distinct work for the whole select and not just the first
field?
-Original Message-
From: Michael Vinson [mailto:[EMAIL PROTECTED]]
Doesn't the distinct work for the whole select and not just the first
field?
-Original Message-
From: Michael Vinson [mailto:[EMAIL PROTECTED]]
Sent: donderdag 1 november 2001 16:45
To: CF-Talk
Subject: sql distinct
My distinct is no longer distinct after a simple, but major, change.
S
11 matches
Mail list logo