How to do join query in laravel?

MS ACCES & VB 6 FIND QUERY - HELP?

• I need the help for find query (two variables) in vb6. I give below the following details: 1) I had created the following files in MS Access : a) tbl_Linemaster : fields – Line_Code, Line_Name b) tbl_Modelmaster: fields - Model_code, Model_Name c) tbl_itemdetails : fields - Line_Code, Model_code, Supplier_Part_code, Description CONTENTS: in tbl_Modelmaster : Model_Code Model_name S1 Bath Soap S2 Detergent S3 Tooth Paste In tbl_Linemaster : Line_code Line_name A1 Hindustan Lever A2 Dabur A3 Promise In tbl_itemdetails Line_code Model_code Supplier_part_code Description A1 S1 L1 Lux A1 S1 H1 Hamam A2 S2 S1 xxxxxx 2) I had created one query in MS Access (name : Qry_find) which is given below: SELECT tbl_manufacturer.Manufacturer_Name, tbl_Model.Model_name, tbl_Linemaster.Line_name, tbl_Itemdetails.Supplier_Part_number, tbl_Itemdetails.Item_Description, tbl_Itemdetails.Local_Language, tbl_Itemdetails.Superceeded_Number, tbl_Itemdetails.Remarks FROM tbl_Linemaster INNER JOIN ((tbl_manufacturer INNER JOIN tbl_Model ON tbl_manufacturer.Manufacturer_Code = tbl_Model.Manufacturer_Code) INNER JOIN tbl_Itemdetails ON (tbl_manufacturer.Manufacturer_Code = tbl_Itemdetails.Manufacturer_code) AND (tbl_Model.Model_number = tbl_Itemdetails.Model_number)) ON tbl_Linemaster.Line_Code = tbl_Itemdetails.Line_Code; In VB 6 : I had used one form and two data combo boxes and one command button and one datagrid1 for finding records. Datacombo1 : for display the model_name from tbl_model_master Datacombo2 : for display the Line_name from tbl_linemaster Datagrid1 : for display the find result. (already I had connected the above query) I need the find result in datagrid1 which model_name in datacombo1 (Bath soap) & line_name in datacombo2 (Hindustal Lever) are equal Please help. Regards CSGanesh

• Answer:

  The way I usually do this is have a "Go" or "Query" command button, and in the code for the Click event of the button I build the SQL statement with the appropriate WHERE clause, then set the grid's datasource to that SQL statement's resulting recordset.