Yeah, it works like a champ! Thanks again sushila

That bottom query would be what the stored procedure generates, but it would dynamically generate that query based on the rule passed to the stored procedure. I think I...

1)Yes, which is part of the reason I am developing this rule-based approach in the first place.

2)Yes, pos_user_type.id = pos_user_type_link.user_type_id; likewise users.id = pos_user_type_link.user_id

3)There is no yes or no. ...

First off, thanks for helping!

From the example above's tables:

pos_user_type(id, description):

1, 'Regular POS user'

2, 'Supervisor'

3, 'Administrator'

pos_user_type_link(user_type_id, user_id):

1, 1

1, 2

1, 3

1, 4

2, 2

2, 3

3, 3

users(id, name):

1, 'joe'

2, 'beth'

3, 'julie'

4, 'paul'

I am attempting...

It's a long story-but I am defining a way to simplify administration of multiple applications each differently under a rule based approach.

application "pos system"

tables

pos_user_type_link(user_type_id, user_id)

pos_user_type(id, description)

application "other system"

tables

other_system_type_link(user_type_id, user_id)

other_system_type(id, description)

universal...

I would use #temp tables but I would like to order the data being inserted into the temp table (and as far as I know I must use @tables instead...