compound keys are not handled

Compound foreign key relationships are not handled properly. Instead of offering to join the two tables on all of the key fields, SQL Prompt offers to join each of the key fields individually.

For example:

create table A ( a_id int not null primary key)

create table B ( a_id int not null foreign key references a(a_id), b_id int not null )
alter table B add constraint PK_b primary key ( a_id, b_id )

create table C ( a_id int not null, b_id int not null, c_id int not null )
alter table C add constraint FK_c_a foreign key ( a_id, b_id ) references b( a_id, b_id)
alter table C add constraint PK_c primary key ( a_id, b_id, c_id )

Typing this SQL:

select * from B join C on 

should result in a popup with one option:

C.a_id = B.a_id and C.b_id = B.b_id

Instead, the popup contains two options:

C.a_id = B.a_id
C.b_id = B.b_id