<div>
Try this.<br />
<br />
SELECT countryshort <br />
FROM tracker<br />
WHERE countryshort IN<br />
(SELECT countryshort FROM ipcityisp WHERE T.iplong BETWEEN ipfrom AND ipto);
</div>


<div>
hi, try this<br />
<br />
select<br />
countryshort<br />
from<br />
ipcityisp INNER JOIN tracker ON tracker.iplong between ipfrom and ipto<br />

</div>


<div>
how exactly do ipcityisp and tracker relate to each other? what is the FK the connects the 2 tables?<br />
<br />
right now, you're trying to compare tracker.iplong and ipcityisp.countryshort (which presumably is a nvarchar), which is why you're getting the error.
</div>


<div>
<div class="content wysiwyg-content">
Hi guys<br />
<br />
i have a table called tracker with alot of records, on each record there is a iplong field which contain a number that i need to lookup data for in another table and then join some fields from that table to the first table. how do i do that?<br />
<br />
something like this?<br />
<br />
<br />
select <br />
countryshort <br />
from <br />
ipcityisp,<br />
tracker<br />
where <br />
tracker.iplong in (select countryshort from ipcityisp where tracker.iplong between ipfrom and ipto)<br />
<br />
the tracker.iplong is a FLOAT and so is IPFROM and IPTO but it just tells me <br />
<br />
Error converting data type nvarchar to float.<br />
<br />
<br />
is this not the right way to do that?<br />

</div>
</div>


Hi guys

i have a table called tracker with alot of records, on each record there is a iplong field which contain a number that i need to lookup data for in another table and then join some fields from that table to the first table. how do i do that?

something like this?


select 
countryshort 
from 
ipcityisp,
tracker
where 
tracker.iplong in (select countryshort from ipcityisp where tracker.iplong between ipfrom and ipto)

the tracker.iplong is a FLOAT and so is IPFROM and IPTO but it just tells me 

Error converting data type nvarchar to float.


is this not the right way to do that?


Try this.

SELECT countryshort 
FROM tracker
WHERE countryshort IN
(SELECT countryshort FROM ipcityisp WHERE T.iplong BETWEEN ipfrom AND ipto);

hi, try this

select
countryshort
from
ipcityisp INNER JOIN tracker ON tracker.iplong between ipfrom and ipto


how exactly do ipcityisp and tracker relate to each other? what is the FK the connects the 2 tables?

right now, you&#39;re trying to compare tracker.iplong and ipcityisp.countryshort (which presumably is a nvarchar), which is why you&#39;re getting the error.

SELECT IN??

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.