select query from table

Devendra Kumar

hello friend i have a select query in which i select all required details like:

SELECT Tbl_Products.ProductId, Tbl_Client_Address.ClientID, Tbl_Client_Address.ClientEmail, Tbl_Client_Address.ClientName, Tbl_Client_Address.ClientMobile, Tbl_Client_Address.ClientStreet+', '+

Tbl_Client_Address.ClientPostal+', '+ Tbl_Client_Address.ClientCity +', '+ Tbl_Client_Address.ClientState+' ,'+Tbl_Client_Address.ClientCountry as address, Tbl_OrderDetail.Qantity,

Tbl_OrderMaster.date, Tbl_Products.Image1, Tbl_OrderMaster.item_amount, Tbl_Products.ProductCode+''+ Tbl_Products.ProductName as proname

FROM Tbl_Client_Address INNER JOIN Tbl_OrderDetail INNER JOIN Tbl_OrderMaster ON Tbl_OrderDetail.OrderMasterfkId = Tbl_OrderMaster.orderId INNER JOIN

Tbl_Products ON Tbl_OrderDetail.ProductFkId = Tbl_Products.ProductId ON Tbl_Client_Address.ClientId = Tbl_OrderMaster.ClientAdrsId

order by date desc

and i have another table transaction in which have common field like clientid

i want select those all client which clien id not in this transaction table

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Devendra Kumar9y ago
hiii Manas Mohapatra please tall me how to insert that select query details in temporary

table and we get my required query there thanks
Devendra Kumar9y ago
hi Manas Mohapatra thanks for rply i will try this

and it return

all records in which same client id

but i want those details

client id not in transaction table

thanks
Manas Mohapatra9y ago
Try like below:
SELECT Tbl_Products.ProductId, Tbl_Client_Address.ClientID, Tbl_Client_Address.ClientEmail, Tbl_Client_Address.ClientName, Tbl_Client_Address.ClientMobile, Tbl_Client_Address.ClientStreet+', '+
Tbl_Client_Address.ClientPostal+', '+ Tbl_Client_Address.ClientCity +', '+ Tbl_Client_Address.ClientState+' ,'+Tbl_Client_Address.ClientCountry as address, Tbl_OrderDetail.Qantity,
Tbl_OrderMaster.date, Tbl_Products.Image1, Tbl_OrderMaster.item_amount, Tbl_Products.ProductCode+''+ Tbl_Products.ProductName as proname
FROM Tbl_OrderDetail
INNER JOIN Tbl_OrderMaster ON Tbl_OrderDetail.OrderMasterfkId = Tbl_OrderMaster.orderId
INNER JOIN Tbl_Products ON Tbl_OrderDetail.ProductFkId = Tbl_Products.ProductId
INNER JOIN Tbl_Client_Address ON Tbl_Client_Address.ClientId = Tbl_OrderMaster.ClientAdrsId
INNER JOIN Tbl_Client_Transaction ON Tbl_Client_Address.ClientId = Tbl_Client_Transaction.ClientId
ORDER BY DATE DESC