mentecky
Posts: 321
|
| Posted: 02/19/2009, 2:32 PM |
|
dodanial,
The SQL code would be something like:
SELECT
f.*,
CONCAT_WS(', ', s1.LastName, s1.FirstName) AS Sig1,
CONCAT_WS(', ', s2.LastName, s2.FirstName) AS Sig2,
CONCAT_WS(', ', s3.LastName, s3.FirstName) AS Sig3
FROM
forms AS f,
users AS s1,
users AS s2,
users AS s3
WHERE
f.Signature1 = s1.user_id AND
f.Signature2 = s2.user_id AND
f.Signature3 = s3.user_id;
That would give you formatted names. In Query builder you can also drop 3 user tables and connect the Signatures to user_id in each user table.
Good Luck,
Rick
_________________
http://www.ccselite.com |
