Jimmy_inc
asked on
help needed with Microsoft SQL Server syntax
select 10 records from customers table for each city then inner join the customerid = customerid of all the tables that have those customerid and therefore returning the city, customerid, tablename and orderdate
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi Jimmy,
sorry...But you posted 3 Questions and all are interlinked so its advisable that post one question with all queries.
Thanks
Bhavesh
sorry...But you posted 3 Questions and all are interlinked so its advisable that post one question with all queries.
Thanks
Bhavesh
ASKER
Hi Brichsoft
Yeah your'e right - Not enough coffee !
I should of only posted this question:
https://www.experts-exchange.com/questions/26887029/help-needed-with-Microsoft-SQL-Server-syntax.html
Which others are interlinked too ?
Yeah your'e right - Not enough coffee !
I should of only posted this question:
https://www.experts-exchange.com/questions/26887029/help-needed-with-Microsoft-SQL-Server-syntax.html
Which others are interlinked too ?
You can use same query and do the join
https://www.experts-exchange.com/questions/26887029/help-needed-with-Microsoft-SQL-Server-syntax.html?anchorAnswerId=35135453#a35135453