Question

How do I combine these two SELECT query into one INSERT?Selecting a value from different tables in ORACLE?

I inserted a row into vehicle_unit by using INSERT this way:

INSERT INTO vehicle_unit(vunit_id,vunit_purchase_price,vunit_exhibition_flag,vehicle_insurance_id,vunit_rego, garage_code)
SELECT '3',50000.00, 'R', 'sports-ute-449-12b ', 'RD3000', garage_code
FROM garage
WHERE garage_email ='melbournec@rdbms.example.com ';

BUT now I do not want to manually enter sports-ute-449-12b. I want to select it from vehicle_detail table using the vehicle_title like this:

SELECT vehicle_insurance_id
FROM vehicle_detail
WHERE vehicle_title= 'Toyota Hilux SR Manual 4x2 MY14 '

But how do I select vehicle_insurance_id from vehicle_detail table AND select garage_code from garage table at the same time to insert into vehicle_unit table?

*The manufacturer_id is the same in both tables.

Answer 1

QO.

ANS:

You can use the multi-query function to execute multiple queries using the dot(.) operator

For Eg:

$sql=Select Vehicle_insurance_id....

$sql.=Select garage_code from garage_table

$sql.=Now Insert Query - Insert into vehincle_unit_table

if(mysqli_multi_query($databaseName,$sql))

{

echo "Successfully Done";

}

else{

echo "Problems in submitting";

}

----------------------------------------------------------------------------------------------------------------------------------------------------------------

THANKS!!