combine 2 sql statement into 1 (1 reply)
Submitted by programmer on Thu, 08/14/2008 - 14:56.
how to combined the below 2 statement into 1 ?
SELECT CONCAT_WS(' ',su.firstName,NULL,su.lastName) as fullName ,
CONCAT_WS(',',fnet.userId,NULL,fnet.friendId) as id , fnet.status as status
from
friends_network fnet join security_user su
on fnet.userId = su.id and fnet.friendId like 'userABC'
SELECT CONCAT_WS(' ',su.firstName,NULL,su.lastName) as fullName ,
CONCAT_WS(',',fnet.userId,NULL,fnet.friendId) as id , fnet.status as status
from
friends_network fnet join security_user su
on fnet.friendId = su.id and fnet.userId like 'requester'
Post Comment