Select join
Why am I getting this error
For
"failed to parse select parameter (wallet_address,created_at,pnl_scoreASpnl_score,(SELECTpnl_scoreFROMscansASs2WHEREs2.wallet_address=scans.wallet_addressANDs2.created_at=scans.created_atANDs2.simulated=true)ASsimulated_pnl_score)" (line 1, column 48)'"failed to parse select parameter (wallet_address,created_at,pnl_scoreASpnl_score,(SELECTpnl_scoreFROMscansASs2WHEREs2.wallet_address=scans.wallet_addressANDs2.created_at=scans.created_atANDs2.simulated=true)ASsimulated_pnl_score)" (line 1, column 48)'For
const { data, error } = await supabase
.from('scans')
.select(`
wallet_address,
created_at,
pnl_score AS pnl_score,
(SELECT pnl_score FROM scans AS s2
WHERE s2.wallet_address = scans.wallet_address
AND s2.created_at = scans.created_at
AND s2.simulated = true
) AS simulated_pnl_score
`)
.eq('simulated', false); const { data, error } = await supabase
.from('scans')
.select(`
wallet_address,
created_at,
pnl_score AS pnl_score,
(SELECT pnl_score FROM scans AS s2
WHERE s2.wallet_address = scans.wallet_address
AND s2.created_at = scans.created_at
AND s2.simulated = true
) AS simulated_pnl_score
`)
.eq('simulated', false); 