HELP!

Hiba Talat — Thu, 23 Sep 2021 03:17:23 +0000

I am trying to work on a project which is available on Youtube.
https://www.youtube.com/watch?v=8rO7ztF4NtU&t=254s&ab_channel=AlexTheAnalyst
But instead of using sqlserver i am doing it on sqlite3 and facing minor challenges.

This query is not working

q7= """UPDATE a.[mytable]
SET PropertyAddress = IFNULL(a.PropertyAddress,b.PropertyAddress)
From mytable AS a
Join mytable AS b
ON a.ParcelID = b.ParcelID
AND a.[UniqueID ] <> b.[UniqueID ]
WHERE a.PropertyAddress IS NULL"""

df = pd.read_sql_query(q7,connection)
df

=======================================
Error:
DatabaseError: Execution failed on sql 'UPDATE a
SET PropertyAddress = IFNULL(a.PropertyAddress,b.PropertyAddress)
From mytable AS a
Join mytable AS b
ON a.ParcelID = b.ParcelID
AND a.[UniqueID ] <> b.[UniqueID ]
WHERE a.PropertyAddress IS NULL': no such table: a

DEV Community: Hiba Talat

HELP!

This query is not working