Can anyone help me out here.
I am trying to figure out a query.
I have 3 tables, I want to get the smallest id ASC from each table and grab just one of those 3 randomly.
First table
listid_a listurl_a
Second table
listid_b listurl_b
Third table
listid_c listurl_c
One more thing, noting is equal to either table.
What I am trying to do is this...
I have is basically 3 list's, and I want to grab one each from each list, and then out of those 3, just get one of those and use the info from that one.
Entirely possible, but a waste of 2 db queries.
Generate a random number from 1-3 switch to said number issue one of the queries according to what number was generated
