Re: Simple Join with no matching primary keys

2017-03-11 Thread Camilo Torres
You can also create a database view from the join of the two tables. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com.

Re: Simple Join with no matching primary keys

2017-03-09 Thread Scot Hacker
On Wednesday, March 8, 2017 at 8:39:43 AM UTC-8, aysh...@gmail.com wrote: > > Tables are coming from different sources, for each single datetime value > there is a different url, in order to tie up the single source data it must > live inside its own table. > So why not make them into one

Re: Simple Join with no matching primary keys

2017-03-08 Thread ayshalab
> > *Sent:* Wednesday, March 8, 2017 8:24 AM > *To:* Django users > *Subject:* Re: Simple Join with no matching primary keys > > > > > > Thanks for your answer, the models represent two different tables, > identical structure but have to be segregated, th

RE: Simple Join with no matching primary keys

2017-03-08 Thread Matthew Pava
Sent: Wednesday, March 8, 2017 8:24 AM To: Django users Subject: Re: Simple Join with no matching primary keys Thanks for your answer, the models represent two different tables, identical structure but have to be segregated, there is no better design options to implement them. Any leads on how

Re: Simple Join with no matching primary keys

2017-03-08 Thread Melvyn Sopacua
On Wednesday 08 March 2017 06:23:44 aysha...@gmail.com wrote: > Thanks for your answer, the models represent two different tables, > identical structure but have to be segregated, there is no better > design options to implement them. Any leads on how to do the join? Think about what the join

Re: Simple Join with no matching primary keys

2017-03-08 Thread ayshalab
Thanks for your answer, the models represent two different tables, identical structure but have to be segregated, there is no better design options to implement them. Any leads on how to do the join? > > > > Models cannot be joined. There is no Model.join(). Models are objects you > can

Re: Simple Join with no matching primary keys

2017-03-08 Thread Melvyn Sopacua
On Tuesday 07 March 2017 10:50:24 aysha...@gmail.com wrote: > Greetings, > > I am trying to do a join on the following 2 models (tables) Models cannot be joined. There is no Model.join(). Models are objects you can relate to eachother. Once you stop thinking in database terms, the problem is

Simple Join with no matching primary keys

2017-03-07 Thread ayshalab
Greetings, I am trying to do a join on the following 2 models (tables) class Rio1(models.Model): datestr = models.DateTimeField() source = models.TextField() dFlag = models.TextField() url = models.TextField() class Meta: managed = False db_table = 'rio1'