Hello,
I am relatively new to doing non-trivial SQL queries.
I have to get data out of 8 diff views based on a parameter Name.
There is a view having name-ssn pairs. All other views have SSN field.
For a person there MAY NOT be data in all the views.
I have to populate data into diff tables in a Report from different
views.
I would like to know what is the best way to approach it.
So far I was trying an Inner join from the Name-ssn vies to all other
views based on the SSN and test for the name field with the input
parameter.
I am thinking there will be problem of Cross join if I dont have data
in all views about a person.
Or the best way is to write query for each view and have all of them in
a stored procedure ?
Any help will be appreciated
Thanks
Bofo