Re: [semi OT] mySQL question

2023-05-12 Thread Bob Sneidar via use-livecode
Just as an aside, I do not bother with joins, if I can help it. If I need data from multiple tables I query each table for just the data I need, and save it in discreet arrays, 1 per table. Of course, my needs are pretty simple. I typically have one parent table (the example suggested calls them

Re: [semi OT] mySQL question

2023-05-12 Thread jbv via use-livecode
Hello Ken, Thank you so much for your answer. Your solution confirms what I had more or less in mind. I will give it a try asap. Best, jbv Le 2023-05-11 15:33, Ken Ray a écrit : I would recommend a table for People, a table for Companies, and a table for Employment that acts as a linking ta

Re: [semi OT] mySQL question

2023-05-11 Thread Ken Ray via use-livecode
I would recommend a table for People, a table for Companies, and a table for Employment that acts as a linking table between the first two. Something like (at its simplest): people id INT(11) first_name VARCHAR(255) last_name VARCHAR(255) companies