How can we help you today? How can we help you today?

Problem with joins in composite keys

Does PrompSQL work with table with composite key.
I'm trying, it's make the ON clause only for the first pair of keys, for the others, I need to do by myself
Ex.
select XX from dbo.TABLE_A op inner join dbo.TABLE_B ana on ana.GRP_Codigo = op.GRP_Codigo and .. from this point, I'm writing by myself...

Thanks

Ésio
EsioN
0

Comments

1 comment

Sort by
  • Bart Read
    Hi there Esio,


    Thanks for reporting this. Unfortunately at the moment SQL Prompt isn't terribly bright when it comes to JOINs using composite keys and will only give you alternatives for matching on a single column in the join. We'll be fixing this in version 3, so it will then work no matter how many columns you have. Sorry I'm not able to provide you with a more immediate solution.


    Many thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.