⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠
Posted 16 October 2014 - 07:36 AM
Hello there!
I have a question how to realize dependent table like as:
Table 'Stores': (Main table) with columns
ID, Name .... etc.
Table 'Schedule' (dependent) with columns:
id, Days, opentime, closetime, storeid
Many records may belong to one Store e.g.
id Name
255 StoreA
256 StoreB
257 StoreN
etc.
--------------------------------------------------------
id days opentime closetime storeid
1 mon-friday 07.00 18.00 255
2 sat 09.00 16.00 255
3 mon-friday 06.00 17.00 256 etc.
Posted 16 October 2014 - 16:21 PM
please express.. what is your real requirement / purpose of the query like ?
