ive three big tables in my bar for large parties
i need to rank them
for example my table of 10 needs to be ranked 8, 9 10 covers
my table of 8 needs to be ranked 6,7,8
my table of 7 needs to be 5,6,7
this will prevent my having to join tables in my restaurant areas which is all 4 and 2
Also we will have the added advantage of not having to relay joins for second service we can try push all the 5 to 10 into the bar where we have fixed size table
am i missing a trick because try as i might i cant seem to rank set table numbers for lower numbers unless a delete joins in the restaurant ...which obviously i cant do ?