Link to home
Start Free TrialLog in
Avatar of Jimmy_inc
Jimmy_incFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of Bhavesh Shah
Bhavesh Shah
Flag of India image

ASKER CERTIFIED SOLUTION
Avatar of Bhavesh Shah
Bhavesh Shah
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi Jimmy,

sorry...But you posted 3 Questions and all are interlinked so its advisable that post one question with all queries.

Thanks

Bhavesh
Avatar of Jimmy_inc

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 ?