I need a SQL database expert who can write me some script which can check values -
Do the following -
We have 4 tables on a database, Example-
Table A - Part_No - 31445814
Table B - Part_No - 31445814, Class - C
Table C - Platform - SPA, Class - C, Version - V
Table D - Version - V
Now From Table A we need to read the Part_No, based on that we need to find out Class from table 2, based on that we need to find Version it should be. In the last match that version named with Table D and make an Output result.
I hope it simple enough to understand.