New user question...

[John Croson]

Here is my query that works...

SELECT CONCAT(LastName, ', ', FirstName) AS FullName,
address_Address.`Phone2`,
address_Address.`Phone1`,
address_AdditionalData.Type,
address_AdditionalData.Value,
address_GroupList.GroupName
FROM address_AdditionalData
RIGHT OUTER JOIN address_Contact ON address_AdditionalData.ID =
address_Contact.ID
INNER JOIN address_Address ON address_Contact.PrimaryAddType =
address_Address.AddType AND address_Contact.ID = address_Address.ID
INNER JOIN address_Groups ON address_Contact.ID = address_Groups.ID
INNER JOIN address_GroupList ON address_Groups.GroupID =
address_GroupList.GroupID
WHERE address_Contact.ID AND address_Groups.ID AND
address_Groups.GroupID AND address_GroupList.GroupID = "3"
ORDER BY FullName;

All I'd like to do is change the WHERE clause to include the values 6
and 7.

I've tried to do this:
AND WHERE address_Contact.ID AND address_Groups.ID AND
address_Groups.GroupID AND address_GroupList.GroupID > "5"

Which won't work.

Any suggestions?

JC

[Randell D.]

"John Croson" <ne**********@spamgourmet.com> wrote in message
news:68**************************@posting.google.c om...

Here is my query that works...

SELECT CONCAT(LastName, ', ', FirstName) AS FullName,
address_Address.`Phone2`,
address_Address.`Phone1`,
address_AdditionalData.Type,
address_AdditionalData.Value,
address_GroupList.GroupName
FROM address_AdditionalData
RIGHT OUTER JOIN address_Contact ON address_AdditionalData.ID =
address_Contact.ID
INNER JOIN address_Address ON address_Contact.PrimaryAddType =
address_Address.AddType AND address_Contact.ID = address_Address.ID
INNER JOIN address_Groups ON address_Contact.ID = address_Groups.ID
INNER JOIN address_GroupList ON address_Groups.GroupID =
address_GroupList.GroupID
WHERE address_Contact.ID AND address_Groups.ID AND
address_Groups.GroupID AND address_GroupList.GroupID = "3"
ORDER BY FullName;

All I'd like to do is change the WHERE clause to include the values 6
and 7.

I've tried to do this:
AND WHERE address_Contact.ID AND address_Groups.ID AND
address_Groups.GroupID AND address_GroupList.GroupID > "5"

Which won't work.

Any suggestions?

JC

I'm a six month newbie but this should work for you...

AND WHERE address_Contact.ID > "5" AND address_Groups.ID > "5" AND
address_Groups.GroupID > "5" AND address_GroupList.GroupID > "5"

[Randell D.]

"John Croson" <ne**********@spamgourmet.com> wrote in message
news:68**************************@posting.google.c om...

Here is my query that works...

SELECT CONCAT(LastName, ', ', FirstName) AS FullName,
address_Address.`Phone2`,
address_Address.`Phone1`,
address_AdditionalData.Type,
address_AdditionalData.Value,
address_GroupList.GroupName
FROM address_AdditionalData
RIGHT OUTER JOIN address_Contact ON address_AdditionalData.ID =
address_Contact.ID
INNER JOIN address_Address ON address_Contact.PrimaryAddType =
address_Address.AddType AND address_Contact.ID = address_Address.ID
INNER JOIN address_Groups ON address_Contact.ID = address_Groups.ID
INNER JOIN address_GroupList ON address_Groups.GroupID =
address_GroupList.GroupID
WHERE address_Contact.ID AND address_Groups.ID AND
address_Groups.GroupID AND address_GroupList.GroupID = "3"
ORDER BY FullName;

All I'd like to do is change the WHERE clause to include the values 6
and 7.

I've tried to do this:
AND WHERE address_Contact.ID AND address_Groups.ID AND
address_Groups.GroupID AND address_GroupList.GroupID > "5"

Which won't work.

Any suggestions?

JC

I'm a six month newbie but this should work for you...

AND WHERE address_Contact.ID > "5" AND address_Groups.ID > "5" AND
address_Groups.GroupID > "5" AND address_GroupList.GroupID > "5"

[John Croson]

Thanks for the tip. I ended up using the old code and just filtering it using PHP...
JC

"Randell D." <yo**************************@yahoo.com> wrote in message news:<ENXjb.115489$6C4.50202@pd7tw1no>...

"John Croson" <ne**********@spamgourmet.com> wrote in message
news:68**************************@posting.google.c om...

Here is my query that works...

SELECT CONCAT(LastName, ', ', FirstName) AS FullName,
address_Address.`Phone2`,
address_Address.`Phone1`,
address_AdditionalData.Type,
address_AdditionalData.Value,
address_GroupList.GroupName
FROM address_AdditionalData
RIGHT OUTER JOIN address_Contact ON address_AdditionalData.ID =
address_Contact.ID
INNER JOIN address_Address ON address_Contact.PrimaryAddType =
address_Address.AddType AND address_Contact.ID = address_Address.ID
INNER JOIN address_Groups ON address_Contact.ID = address_Groups.ID
INNER JOIN address_GroupList ON address_Groups.GroupID =
address_GroupList.GroupID
WHERE address_Contact.ID AND address_Groups.ID AND
address_Groups.GroupID AND address_GroupList.GroupID = "3"
ORDER BY FullName;

All I'd like to do is change the WHERE clause to include the values 6
and 7.

I've tried to do this:
AND WHERE address_Contact.ID AND address_Groups.ID AND
address_Groups.GroupID AND address_GroupList.GroupID > "5"

Which won't work.

Any suggestions?

JC

I'm a six month newbie but this should work for you...

AND WHERE address_Contact.ID > "5" AND address_Groups.ID > "5" AND
address_Groups.GroupID > "5" AND address_GroupList.GroupID > "5"

[John Croson]

Thanks for the tip. I ended up using the old code and just filtering it using PHP...
JC

"Randell D." <yo**************************@yahoo.com> wrote in message news:<ENXjb.115489$6C4.50202@pd7tw1no>...

"John Croson" <ne**********@spamgourmet.com> wrote in message
news:68**************************@posting.google.c om...

Here is my query that works...

SELECT CONCAT(LastName, ', ', FirstName) AS FullName,
address_Address.`Phone2`,
address_Address.`Phone1`,
address_AdditionalData.Type,
address_AdditionalData.Value,
address_GroupList.GroupName
FROM address_AdditionalData
RIGHT OUTER JOIN address_Contact ON address_AdditionalData.ID =
address_Contact.ID
INNER JOIN address_Address ON address_Contact.PrimaryAddType =
address_Address.AddType AND address_Contact.ID = address_Address.ID
INNER JOIN address_Groups ON address_Contact.ID = address_Groups.ID
INNER JOIN address_GroupList ON address_Groups.GroupID =
address_GroupList.GroupID
WHERE address_Contact.ID AND address_Groups.ID AND
address_Groups.GroupID AND address_GroupList.GroupID = "3"
ORDER BY FullName;

All I'd like to do is change the WHERE clause to include the values 6
and 7.

I've tried to do this:
AND WHERE address_Contact.ID AND address_Groups.ID AND
address_Groups.GroupID AND address_GroupList.GroupID > "5"

Which won't work.

Any suggestions?

JC

I'm a six month newbie but this should work for you...

AND WHERE address_Contact.ID > "5" AND address_Groups.ID > "5" AND
address_Groups.GroupID > "5" AND address_GroupList.GroupID > "5"