Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to resolve the loops?
Thanks in advance.
Age_group:
LOAD `age_group_id`,
`age_min`,
`age_max`,
`age_range`;
SQL SELECT *
FROM `C:\Island Marketing\club`.`Age_group`;
City:
LOAD `city_id`,
city,
`region_id`;
SQL SELECT *
FROM `C:\Island Marketing\club`.City;
Country:
LOAD `country_id`,
country;
SQL SELECT *
FROM `C:\Island Marketing\club`.Country;
LOAD `cust_id`,
`first_name`,
`last_name`,
age,
`phone_number`,
address,
`city_id`,
`sales_id`,
`sponsor_id`;
SQL SELECT *
FROM `C:\Island Marketing\club`.Customer;
Customer:
LOAD `inv_id`,
`service_id`,
days,
`nb_guests`;
Invoice_Line:
SQL SELECT *
FROM `C:\Island Marketing\club`.`Invoice_Line`;
LOAD `region_id`,
region,
`country_id`;
SQL SELECT *
FROM `C:\Island Marketing\club`.Region;
Region:
LOAD `sl_id`,
`region_id`,
`sales_revenue`;
Region_SLine:
SQL SELECT *
FROM `C:\Island Marketing\club`.`Region_SLine`;
LOAD `res_id`,
`service_id`,
`res_days`,
`future_guests`;
Reservation_Line:
SQL SELECT *
FROM `C:\Island Marketing\club`.`Reservation_Line`;
LOAD `res_id`,
`cust_id`,
`res_date`;
Reservations:
SQL SELECT *
FROM `C:\Island Marketing\club`.Reservations;
Resort:
LOAD `resort_id`,
resort,
`country_id`;
SQL SELECT *
FROM `C:\Island Marketing\club`.Resort;
Sales:
LOAD `inv_id`,
`cust_id`,
`invoice_date`;
SQL SELECT *
FROM `C:\Island Marketing\club`.Sales;
Sales_Person:
LOAD `sales_id`,
`sales_person`;
SQL SELECT *
FROM `C:\Island Marketing\club`.`Sales_Person`;
Service:
LOAD `service_id`,
service,
`sl_id`,
price;
SQL SELECT *
FROM `C:\Island Marketing\club`.Service;
Service_Line:
LOAD `sl_id`,
`service_line`,
`resort_id`;
SQL SELECT *
FROM `C:\Island Marketing\club`.`Service_Line`;
//-------- End Multiple Select Statements ------
Thank you Kunal.