sqlite?
6 posts
Page 1 of 1
Hello,
who can help me
with this part i want
can't find anything :(
i tried:
i want to load all data and get the icon from the other table.
thanks
who can help me
with this part i want
can't find anything :(
i tried:
Code: Select all
but didn't work "SELECT cash.description, categories_transactions.icon_ FROM(cash) INNER JOIN categories_transactions WHERE cash.description"
i want to load all data and get the icon from the other table.
thanks
visit us on:
http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
Your go to guy for this would be #smashapps he is a guru with visual basics databases
Well you have WHERE cash.description
you aren't specifying it's value i.e WHERE cash.description=1
Then it would select the row of data where the cash.description is equal to 1.
you aren't specifying it's value i.e WHERE cash.description=1
Then it would select the row of data where the cash.description is equal to 1.
My name is Tom | Visit my blog where I post new content every day! Tom's Daily Blog | MineCraft is awesome!
hi again,
well i want just all records from the table cash
so is there any way to get all the data and get the icon_ from categories
i know if you do SELECT * you get all data
but can't be sure from this join part
well i want just all records from the table cash
so is there any way to get all the data and get the icon_ from categories
i know if you do SELECT * you get all data
but can't be sure from this join part
visit us on:
http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
You can only use INNER JOIN if there are rows that match in both of the tables for example a First name column
Pretend I have two tables, im going to call one Table1 and other is Table2, Table1 will have the columns FirstName and LastName and table2 will have FirstName PhoneNumber
SELECT table1.FirstName, table1.LastName, table2.FirstName, table2.PhoneNumber FROM table1 INNER JOIN table2 ON table1.FirstName=table2.FirstName
Hopefully that should work otherwise just look up "SQL INNER JOIN"
Pretend I have two tables, im going to call one Table1 and other is Table2, Table1 will have the columns FirstName and LastName and table2 will have FirstName PhoneNumber
SELECT table1.FirstName, table1.LastName, table2.FirstName, table2.PhoneNumber FROM table1 INNER JOIN table2 ON table1.FirstName=table2.FirstName
Hopefully that should work otherwise just look up "SQL INNER JOIN"
My name is Tom | Visit my blog where I post new content every day! Tom's Daily Blog | MineCraft is awesome!
haha thanks #smashapps
it works
+rep
:( sorry can't +rep its not allowed :(
it works
+rep
:( sorry can't +rep its not allowed :(
visit us on:
http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
6 posts
Page 1 of 1
Copyright Information
Copyright © Codenstuff.com 2020 - 2023