sql query for selecting similar data from column supplier in table1 and table 2 and if data matches then need to pull out client info and user info of those matched ids which are seperate columns form table 1
Create a query - add the 2 tables, click the supplier field on the left table, click and hold the left mouse button down and drag it to the supplier field on the right table.