asmhatreandClaude Sonnet 5.5
d03962ea9c
Co-Authored-By: Claude Sonnet 5.5 <[email protected]> Claude-Session: https://claude.ai/code/session_01Cfo2K4u4rF18QsPXPFnytf
6 lines
450 B
Plaintext
6 lines
450 B
Plaintext
tables: [bankpayment, cardpayment, payment, shape]
|
|
JOINED 'from Payment' returned 2 rows
|
|
SINGLE_TABLE 'from Shape' returned 2 rows
|
|
SQL> select p1_0.id,case when p1_2.id is not null then 1 when p1_1.id is not null then 2 end,p1_0.amount,p1_1.iban,p1_2.last4 from Payment p1_0 left join BankPayment p1_1 on p1_0.id=p1_1.id left join CardPayment p1_2 on p1_0.id=p1_2.id
|
|
SQL> select s1_0.id,s1_0.kind,s1_0.label,s1_0.radius,s1_0.side from Shape s1_0
|